package com.fishery.processing.mapper;

import com.fishery.processing.entity.Qualification;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.fishery.processing.entity.vo.QualificationVo;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author ${author}
 * @since 2021-01-14
 */
public interface QualificationMapper extends BaseMapper<Qualification> {

    @Select("SELECT id, product_id, inspection_report, quality_certificate, safety_certificate, license, product_info" +
            ", standard FROM t_processing_product_qualification WHERE product_id = #{productId}")
    public QualificationVo getQualificationOfProduct(String productId);

}
